package com.example.springboot005tx.provider;

import com.example.springboot005tx.pojo.UserInfo;

/**
 * @description: TODO
 * @author: uu
 * @data: 2023/6/18 21:16
 * @version: v1.0
 */
public class UserInfoProvider {
    public static String insert(UserInfo userInfo){
        return """
                insert into user_info values(#{id},#{name},#{age},#{sex});
                """;
    }

    public static String selectById(Integer id){
        return """
                select * from user_info where id = #{id};
                """;
    }

    public static String selectAll(){
        return """
                select * from user_info;
                """;
    }
}
